Employee_Attrition_Profile

Dataset statistics

Number of variables	15
Number of observations	1000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	530.9 KiB
Average record size in memory	543.7 B

Variable types

NUM	7
CAT	5
BOOL	3

Reproduction

Analysis started	2020-06-21 09:14:03.105901
Analysis finished	2020-06-21 09:14:17.046301
Duration	13.94 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`TrainingTimesLastYear` has 34 (3.4%) zeros	Zeros
`PropRoleComp` has 169 (16.9%) zeros	Zeros

Attrition
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

0	843
1	157

Frequency Table

Value	Count	Frequency (%)
0	843	84.3%
1	157	15.7%

BusinessTravel
Categorical

Distinct count	3
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

Travel_Rarely	709
Travel_Frequently	199
Non-Travel	92

Value	Count	Frequency (%)
Travel_Rarely	709	70.9%
Travel_Frequently	199	19.9%
Non-Travel	92	9.2%

Length

Max length	17
Mean length	13.52
Min length	10

Value	Count	Frequency (%)
Lowercase_Letter	11	64.7%
Uppercase_Letter	4	23.5%
Dash_Punctuation	1	5.9%
Connector_Punctuation	1	5.9%

Value	Count	Frequency (%)
Latin	15	88.2%
Common	2	11.8%

Value	Count	Frequency (%)
ASCII	17	100.0%

DistanceFromHome
Real number (ℝ_≥0)

Distinct count	29
Unique (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9.145
Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	7
Q3	13
95-th percentile	26
Maximum	29
Range	28
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.120955912
Coefficient of variation (CV)	0.8880214229
Kurtosis	-0.1030362226
Mean	9.145
Median Absolute Deviation (MAD)	5
Skewness	1.008336875
Sum	9145
Variance	65.94992492

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	143	14.3%
1	142	14.2%
9	65	6.5%
7	62	6.2%
10	58	5.8%
3	52	5.2%
8	52	5.2%
4	45	4.5%
5	44	4.4%
6	44	4.4%
Other values (19)	293	29.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	142	14.2%
2	143	14.3%
3	52	5.2%
4	45	4.5%
5	44	4.4%

Value	Count	Frequency (%)
29	21	2.1%
28	17	1.7%
27	9	0.9%
26	18	1.8%
25	17	1.7%

EnvironmentSatisfaction
Categorical

Distinct count	4
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

4	308
3	304
2	196
1	192

Value	Count	Frequency (%)
4	308	30.8%
3	304	30.4%
2	196	19.6%
1	192	19.2%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Decimal_Number	4	100.0%

Value	Count	Frequency (%)
Common	4	100.0%

Value	Count	Frequency (%)
ASCII	4	100.0%

JobRole
Categorical

Distinct count	9
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

Sales Executive	217
Research Scientist	209
Laboratory Technician	166
Manufacturing Director	97
Healthcare Representative	90
Other values (4)	221

Value	Count	Frequency (%)
Sales Executive	217	21.7%
Research Scientist	209	20.9%
Laboratory Technician	166	16.6%
Manufacturing Director	97	9.7%
Healthcare Representative	90	9.0%
Manager	74	7.4%
Sales Representative	64	6.4%
Research Director	47	4.7%
Human Resources	36	3.6%

Length

Max length	25
Mean length	18.024
Min length	7

Value	Count	Frequency (%)
Lowercase_Letter	20	69.0%
Uppercase_Letter	8	27.6%
Space_Separator	1	3.4%

Value	Count	Frequency (%)
Latin	28	96.6%
Common	1	3.4%

Value	Count	Frequency (%)
ASCII	29	100.0%

JobSatisfaction
Categorical

Distinct count	4
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

3	321
4	306
1	188
2	185

Value	Count	Frequency (%)
3	321	32.1%
4	306	30.6%
1	188	18.8%
2	185	18.5%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Decimal_Number	4	100.0%

Value	Count	Frequency (%)
Common	4	100.0%

Value	Count	Frequency (%)
ASCII	4	100.0%

MaritalStatus
Categorical

Distinct count	3
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

Married	469
Single	314
Divorced	217

Value	Count	Frequency (%)
Married	469	46.9%
Single	314	31.4%
Divorced	217	21.7%

Length

Max length	8
Mean length	6.903
Min length	6

Value	Count	Frequency (%)
Lowercase_Letter	11	78.6%
Uppercase_Letter	3	21.4%

Value	Count	Frequency (%)
Latin	14	100.0%

Value	Count	Frequency (%)
ASCII	14	100.0%

OverTime
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

No	716
Yes	284

Frequency Table

Value	Count	Frequency (%)
No	716	71.6%
Yes	284	28.4%

TrainingTimesLastYear
Real number (ℝ_≥0)

ZEROS

Distinct count	7
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.841
Minimum	0
Maximum	6
Zeros	34
Zeros (%)	3.4%
Memory size	15.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.300542352
Coefficient of variation (CV)	0.4577762592
Kurtosis	0.4313947547
Mean	2.841
Median Absolute Deviation (MAD)	1
Skewness	0.5676822032
Sum	2841
Variance	1.69141041

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	362	36.2%
3	346	34.6%
5	89	8.9%
4	75	7.5%
6	48	4.8%
1	46	4.6%
0	34	3.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	3.4%
1	46	4.6%
2	362	36.2%
3	346	34.6%
4	75	7.5%

Value	Count	Frequency (%)
6	48	4.8%
5	89	8.9%
4	75	7.5%
3	346	34.6%
2	362	36.2%

CommunicationSkill
Real number (ℝ_≥0)

Distinct count	5
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.041
Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	5
Maximum	5
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.413972531
Coefficient of variation (CV)	0.4649695926
Kurtosis	-1.296248835
Mean	3.041
Median Absolute Deviation (MAD)	1
Skewness	-0.0428380009
Sum	3041
Variance	1.999318318

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	207	20.7%
4	206	20.6%
3	201	20.1%
2	193	19.3%
1	193	19.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	193	19.3%
2	193	19.3%
3	201	20.1%
4	206	20.6%
5	207	20.7%

Value	Count	Frequency (%)
5	207	20.7%
4	206	20.6%
3	201	20.1%
2	193	19.3%
1	193	19.3%

OwnStocks
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

1	572
0	428

Frequency Table

Value	Count	Frequency (%)
1	572	57.2%
0	428	42.8%

PropWorkLife
Real number (ℝ_≥0)

Distinct count	346
Unique (%)	34.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.28684550215494325
Minimum	0.0
Maximum	0.6727272727272727
Zeros	7
Zeros (%)	0.7%
Memory size	15.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.04751082251
Q1	0.1794871795
median	0.2631578947
Q3	0.4
95-th percentile	0.5661672216
Maximum	0.6727272727
Range	0.6727272727
Interquartile range (IQR)	0.2205128205

Descriptive statistics

Standard deviation	0.1538261788
Coefficient of variation (CV)	0.5362684012
Kurtosis	-0.5050614235
Mean	0.2868455022
Median Absolute Deviation (MAD)	0.09465881685
Skewness	0.43071975
Sum	286.8455022
Variance	0.0236624933

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.3333333333	22	2.2%
0.2	21	2.1%
0.5	19	1.9%
0.25	18	1.8%
0.2222222222	17	1.7%
0.2857142857	16	1.6%
0.3076923077	13	1.3%
0.3225806452	13	1.3%
0.1666666667	12	1.2%
0.4	12	1.2%
Other values (336)	837	83.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	0.7%
0.01960784314	1	0.1%
0.02222222222	1	0.1%
0.02631578947	1	0.1%
0.02857142857	6	0.6%

Value	Count	Frequency (%)
0.6727272727	2	0.2%
0.6666666667	1	0.1%
0.6607142857	1	0.1%
0.6603773585	1	0.1%
0.6551724138	1	0.1%

PropExpComp
Real number (ℝ_≥0)

Distinct count	154
Unique (%)	15.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.143472619047619
Minimum	0.0
Maximum	38.0
Zeros	7
Zeros (%)	0.7%
Memory size	15.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.5
Q1	1.6
median	3
Q3	5
95-th percentile	10.5
Maximum	38
Range	38
Interquartile range (IQR)	3.4

Descriptive statistics

Standard deviation	4.063484827
Coefficient of variation (CV)	0.9806954699
Kurtosis	17.54727075
Mean	4.143472619
Median Absolute Deviation (MAD)	1.8
Skewness	3.270087499
Sum	4143.472619
Variance	16.51190894

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	81	8.1%
3	59	5.9%
0.5	57	5.7%
2	54	5.4%
1	47	4.7%
4	47	4.7%
2.5	42	4.2%
6	35	3.5%
10	29	2.9%
4.5	26	2.6%
Other values (144)	523	52.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	0.7%
0.3	2	0.2%
0.375	1	0.1%
0.4	3	0.3%
0.4285714286	1	0.1%

Value	Count	Frequency (%)
38	1	0.1%
37	1	0.1%
34	2	0.2%
28	1	0.1%
23	1	0.1%

PropRoleComp
Real number (ℝ_≥0)

ZEROS

Distinct count	102
Unique (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.47968325589587163
Minimum	0.0
Maximum	0.875
Zeros	169
Zeros (%)	16.9%
Memory size	15.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.3333333333
median	0.5
Q3	0.6666666667
95-th percentile	0.8503571429
Maximum	0.875
Range	0.875
Interquartile range (IQR)	0.3333333333

Descriptive statistics

Standard deviation	0.2757928221
Coefficient of variation (CV)	0.574947778
Kurtosis	-0.8713633137
Mean	0.4796832559
Median Absolute Deviation (MAD)	0.1666666667
Skewness	-0.5622562819
Sum	479.6832559
Variance	0.07606168074

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	169	16.9%
0.6666666667	139	13.9%
0.5	135	13.5%
0.3333333333	55	5.5%
0.875	46	4.6%
0.6	46	4.6%
0.7777777778	38	3.8%
0.4	34	3.4%
0.7	25	2.5%
0.8181818182	21	2.1%
Other values (92)	292	29.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	169	16.9%
0.0625	1	0.1%
0.06666666667	1	0.1%
0.08695652174	1	0.1%
0.1071428571	1	0.1%

Value	Count	Frequency (%)
0.875	46	4.6%
0.8666666667	1	0.1%
0.8571428571	3	0.3%
0.85	1	0.1%
0.8461538462	3	0.3%

PropEducationAgeWy
Real number (ℝ_≥0)

Distinct count	190
Unique (%)	19.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.06524792881469622
Minimum	0.011235955056179775
Maximum	0.16666666666666666
Zeros	0
Zeros (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	0.01123595506
5-th percentile	0.0249695122
Q1	0.04347826087
median	0.06138147567
Q3	0.08510638298
95-th percentile	0.1142857143
Maximum	0.1666666667
Range	0.1554307116
Interquartile range (IQR)	0.04162812211

Descriptive statistics

Standard deviation	0.02851788693
Coefficient of variation (CV)	0.437069612
Kurtosis	0.1831752779
Mean	0.06524792881
Median Absolute Deviation (MAD)	0.019714809
Skewness	0.5724322994
Sum	65.24792881
Variance	0.0008132698751

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.09090909091	27	2.7%
0.07142857143	25	2.5%
0.1	22	2.2%
0.05882352941	21	2.1%
0.0625	21	2.1%
0.05	20	2.0%
0.05555555556	19	1.9%
0.08333333333	18	1.8%
0.07692307692	18	1.8%
0.06666666667	17	1.7%
Other values (180)	792	79.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01123595506	1	0.1%
0.01265822785	2	0.2%
0.01282051282	1	0.1%
0.01298701299	1	0.1%
0.01351351351	1	0.1%

Value	Count	Frequency (%)
0.1666666667	4	0.4%
0.1515151515	2	0.2%
0.15	3	0.3%
0.1428571429	5	0.5%
0.1379310345	1	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	Attrition	BusinessTravel	DistanceFromHome	EnvironmentSatisfaction	JobRole	JobSatisfaction	MaritalStatus	OverTime	TrainingTimesLastYear	CommunicationSkill	OwnStocks	PropWorkLife	PropExpComp	PropRoleComp	PropEducationAgeWy
0	0	Non-Travel	2	3	Laboratory Technician	4	Single	No	2	4	0	0.400000	12.000000	0.583333	0.071429
1	0	Travel_Rarely	12	3	Manufacturing Director	3	Married	Yes	2	2	1	0.194444	0.700000	0.500000	0.093023
2	1	Travel_Rarely	2	3	Sales Executive	4	Single	No	3	5	0	0.218182	2.400000	0.700000	0.014925
3	0	Travel_Rarely	24	1	Research Scientist	4	Single	No	2	4	0	0.461538	2.250000	0.875000	0.017544
4	0	Travel_Rarely	3	3	Manufacturing Director	3	Married	No	2	1	1	0.270270	5.000000	0.636364	0.063830
5	0	Travel_Rarely	7	2	Sales Representative	3	Married	No	2	2	0	0.419355	3.250000	0.875000	0.090909
6	1	Travel_Rarely	1	4	Laboratory Technician	3	Single	Yes	2	1	0	0.125000	4.000000	0.500000	0.083333
7	0	Travel_Rarely	4	1	Laboratory Technician	2	Married	No	5	5	0	0.242424	0.888889	0.666667	0.097561
8	0	Travel_Frequently	11	4	Sales Executive	4	Divorced	No	3	4	1	0.142857	2.500000	0.333333	0.050000
9	1	Travel_Rarely	7	2	Sales Representative	2	Single	No	3	5	0	0.047619	0.500000	0.000000	0.045455

Last rows

	Attrition	BusinessTravel	DistanceFromHome	EnvironmentSatisfaction	JobRole	JobSatisfaction	MaritalStatus	OverTime	TrainingTimesLastYear	CommunicationSkill	OwnStocks	PropWorkLife	PropExpComp	PropRoleComp	PropEducationAgeWy
990	0	Travel_Frequently	6	1	Laboratory Technician	1	Married	Yes	3	5	1	0.250000	2.250000	0.500000	0.088889
991	0	Travel_Frequently	10	4	Research Scientist	3	Divorced	Yes	4	1	1	0.147059	2.500000	0.500000	0.102564
992	0	Travel_Rarely	1	3	Healthcare Representative	4	Divorced	No	5	3	1	0.487179	19.000000	0.526316	0.051724
993	1	Travel_Frequently	9	3	Sales Executive	3	Married	No	3	3	0	0.531915	3.125000	0.208333	0.041667
994	0	Travel_Rarely	7	3	Healthcare Representative	1	Married	No	1	1	1	0.232558	1.111111	0.000000	0.056604
995	0	Non-Travel	10	2	Sales Executive	4	Single	No	3	4	0	0.277778	5.000000	0.272727	0.086957
996	0	Travel_Rarely	16	3	Manufacturing Director	4	Single	Yes	2	2	0	0.450000	2.571429	0.400000	0.051724
997	1	Travel_Rarely	9	3	Sales Executive	4	Single	No	3	4	0	0.195652	4.500000	0.800000	0.036364
998	0	Travel_Rarely	2	3	Manufacturing Director	4	Single	Yes	4	5	0	0.400000	2.000000	0.000000	0.071429
999	0	Travel_Frequently	2	3	Sales Executive	2	Married	No	2	3	1	0.566038	10.000000	0.437500	0.036145

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows